package com.opo5.logisticsmanagement.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.opo5.logisticsmanagement.Vo.CableVo;
import com.opo5.logisticsmanagement.Vo.NewVo;
import com.opo5.logisticsmanagement.domain.CablePlan;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface CablePlanDao extends BaseMapper<CablePlan> {
    @Select("SELECT s.expectedlength,s.innum,s.outnum,s.expectedlength*0.1 weight,s.projectname\n" +
            "FROM tbs_cableplan s")
    Page<CableVo> cable(Page<CableVo> iPage);
}
